Search Results for: "colt m4 22"

select * from tb_mfg_promo.dbo.tb_search_redirect with (nolock) where kword='colt m4 22' and kword <> '' and kword is not NULL and site='sportsman'

SELECT distinct a.style_id,
 case a.style_id 
 
 when 123774 then 1 
 when 123997 then 2 
 when 309353 then 3 
 when 268616 then 4 
 when 151161 then 5 
 when 298346 then 6 
 when 162071 then 7 
 when 96036 then 8 
 when 249289 then 9 
 when 179649 then 10 
 when 262789 then 11 
 when 262786 then 12 
 when 278790 then 13 
 when 262787 then 14 
 when 278792 then 15 
 when 114636 then 16 
 when 278789 then 17 
 when 262788 then 18 
 when 262785 then 19 
 when 281593 then 20 
 when 169790 then 21 
 when 125824 then 22 
 when 124084 then 23 
 when 102294 then 24 
 when 13880 then 25 
 when 254378 then 26 
 when 196372 then 27 
 when 176432 then 28 
 when 264021 then 29 
 when 274155 then 30 
 when 125506 then 31 
 when 129071 then 32 
 when 73377 then 33 
 when 188658 then 34 
 when 206165 then 35 
 when 211308 then 36 
 when 301818 then 37 
 when 113256 then 38 
 when 294638 then 39 
 when 113259 then 40 
 when 113258 then 41 
 when 157814 then 42 
 when 155325 then 43 
 when 155326 then 44 
 when 60304 then 45 
 when 129072 then 46 
 when 112778 then 47 
 when 113775 then 48 
 when 175529 then 49 
 when 163820 then 50 
 when 141442 then 51 
 when 278799 then 52 
 when 155531 then 53 
 when 155707 then 54 
 when 153394 then 55 
 when 151120 then 56 
 when 249294 then 57 
 when 264023 then 58 
 when 193177 then 59 
 when 193170 then 60 
 when 193175 then 61 
 when 193176 then 62 
 when 227139 then 63 
 when 226079 then 64 
 when 172343 then 65 
 when 147500 then 66 
 when 22910 then 67 
 when 193161 then 68 
 when 132455 then 69 
 when 138430 then 70 
 when 288126 then 71 
 when 248839 then 72 
 when 147372 then 73 
 when 247275 then 74 
 when 290518 then 75 
 when 291873 then 76 
 when 309332 then 77 
 when 263885 then 78 
 when 292051 then 79 
 when 232185 then 80 
 when 260691 then 81 
 when 263876 then 82 
 when 247277 then 83 
 when 138429 then 84 
 when 267463 then 85 
 when 195643 then 86 
 when 117136 then 87 
 when 155342 then 88 
 when 296224 then 89 
 when 296429 then 90 
 when 23952 then 91 
 when 250963 then 92 
 when 44757 then 93 
 when 206503 then 94 
 when 205230 then 95 
 when 260698 then 96 
 when 260758 then 97 
 when 266940 then 98 
 when 156651 then 99 
 when 161606 then 100 
 when 266942 then 101 
 when 263891 then 102 
 when 205082 then 103 
 when 142999 then 104 
 when 249560 then 105 
 when 184032 then 106 
 when 131365 then 107 
 when 266941 then 108 
 when 149795 then 109 
 when 149799 then 110 
 when 206286 then 111 
 when 305046 then 112 
 when 44754 then 113 
 when 124007 then 114 
 when 102137 then 115 
 when 158990 then 116 
 when 22936 then 117 
 when 250769 then 118 
 when 282191 then 119 
 when 229142 then 120 
 when 247581 then 121 
 when 285144 then 122 
 when 61945 then 123 
 when 121650 then 124 
 when 301816 then 125 
 when 158504 then 126 
 when 23379 then 127 
 when 108208 then 128 
 when 144634 then 129 
 when 175327 then 130 
 when 61833 then 131 
 when 108807 then 132 
 when 293042 then 133 
 when 257011 then 134 
 when 36610 then 135 
 when 297892 then 136 
 when 173699 then 137 
 when 303610 then 138 
 when 147502 then 139 
 when 112779 then 140 
 when 75029 then 141 
 when 179775 then 142 
 when 252219 then 143 
 when 125778 then 144 
 when 165139 then 145 
 when 159122 then 146 
 when 267630 then 147 
 when 42264 then 148 
 when 161536 then 149 
 when 189907 then 150 
 when 257087 then 151 
 when 189906 then 152 
 when 197835 then 153 
 when 112078 then 154 
 when 165130 then 155 
 when 277581 then 156 
 when 161337 then 157 
 when 214082 then 158 
 when 193148 then 159 
 when 36622 then 160 
 when 267710 then 161 
 when 257024 then 162 
 when 213251 then 163 
 when 193157 then 164 
 when 108741 then 165 
 when 161335 then 166 
 when 290036 then 167 
 when 217694 then 168 
 when 290041 then 169 
 when 285678 then 170 
 when 291965 then 171 
 when 22908 then 172 
 when 247663 then 173 
 when 150075 then 174 
 when 271791 then 175 
 when 113118 then 176 
 when 176063 then 177 
 when 289443 then 178 
 when 289434 then 179 
 when 300593 then 180 
 when 121561 then 181 
 when 273263 then 182 
 when 107404 then 183 
 when 23391 then 184 
 when 145410 then 185 
 when 225887 then 186 
 when 74926 then 187 
 when 281594 then 188 
 when 7339 then 189 
 when 127015 then 190 
 when 281256 then 191 
 when 266632 then 192 
 when 195861 then 193 
 when 153353 then 194 
 when 260969 then 195 
 when 277071 then 196 
 when 277073 then 197 
 when 280317 then 198 
 when 277038 then 199 
 when 290037 then 200 
 when 107665 then 201 
 when 169754 then 202 
 when 301817 then 203 
 when 133125 then 204 
 when 282175 then 205 
 when 165311 then 206 
 when 129145 then 207 
 when 227148 then 208 
 when 285765 then 209 
 when 292373 then 210 
 when 277072 then 211 
 when 292144 then 212 
 when 168709 then 213 
 when 281089 then 214 
 when 285951 then 215 
 when 289038 then 216 
 when 4473 then 217 
 when 287422 then 218 
 when 123667 then 219 
 when 176459 then 220 
 when 161668 then 221 
 when 247528 then 222 
 when 23410 then 223 
 when 193141 then 224 
 when 266102 then 225 
 when 286272 then 226 
 when 279940 then 227 
 when 117771 then 228 
 when 276668 then 229 
 when 287624 then 230 
 when 121755 then 231 
 when 68469 then 232 
 when 56380 then 233 
 when 205776 then 234 
 when 273433 then 235 
 when 288582 then 236 
 when 203321 then 237 
 when 283371 then 238 
 when 283212 then 239 
 when 133694 then 240 
 when 286274 then 241 
 when 117637 then 242 
 when 251722 then 243 
 when 257088 then 244 
 when 267765 then 245 
 when 293008 then 246 
 when 252874 then 247 
 when 117577 then 248 
 when 222537 then 249 
 when 120478 then 250 
 when 44677 then 251 
 when 119052 then 252 
 when 213252 then 253 
 when 59844 then 254 
 when 135490 then 255 
 when 252485 then 256 
 when 297549 then 257 
 when 202771 then 258 
 when 193278 then 259 
 when 309733 then 260 
 when 141297 then 261 
 when 253445 then 262 
 when 204268 then 263 
 when 193139 then 264 
 when 213783 then 265 
 when 246217 then 266 
 when 302337 then 267 
 when 300646 then 268 
 when 139985 then 269 
 when 279998 then 270 
 when 271477 then 271 
 when 194075 then 272 
 when 218523 then 273 
 when 267028 then 274 
 when 297545 then 275 
 when 263765 then 276 
 when 305217 then 277 
 when 216748 then 278 
 when 298378 then 279 
 when 168708 then 280 
 when 173050 then 281 
 when 122387 then 282 
 when 286923 then 283 
 when 75189 then 284 
 when 306716 then 285 
 when 247495 then 286 
 when 247498 then 287 
 when 247500 then 288 
 when 23409 then 289 
 when 227194 then 290 
 when 222566 then 291 
 when 283436 then 292 
 when 281103 then 293 
 when 4747 then 294 
 when 137552 then 295 
 when 272145 then 296 
 when 124425 then 297 
 when 196898 then 298 
 when 210683 then 299 
 when 280321 then 300 
 when 58934 then 301 
 when 260755 then 302 
 when 263688 then 303 
 when 301820 then 304 
 when 170759 then 305 
 when 153053 then 306 
 when 134636 then 307 
 when 291471 then 308 
 when 44842 then 309 
 when 255787 then 310 
 when 260834 then 311 
 when 60285 then 312 
 when 289549 then 313 
 when 267031 then 314 
 when 213253 then 315 
 when 170447 then 316 
 when 84075 then 317 
 when 215985 then 318 
 when 206509 then 319 
 when 297396 then 320 
 when 172030 then 321 
 when 154577 then 322 
 when 85475 then 323 
 when 219848 then 324 
 when 260564 then 325 
 when 268873 then 326 
 when 272954 then 327 
 when 203293 then 328 
 when 278922 then 329 
 when 141443 then 330 
 when 206666 then 331 
 when 281255 then 332 
 when 233710 then 333 
 when 60301 then 334 
 when 203499 then 335 
 when 306704 then 336 
 when 244952 then 337 
 when 124936 then 338 
 when 121987 then 339 
 when 12669 then 340 
 when 282380 then 341 
 when 291252 then 342 
 when 281683 then 343 
 when 201672 then 344 
 when 245412 then 345 
 when 252688 then 346 
 when 84849 then 347 
 when 283360 then 348 
 when 288084 then 349 
 when 247770 then 350 
 when 254112 then 351 
 when 205208 then 352 
 when 201266 then 353 
 when 261499 then 354 
 when 194068 then 355 
 when 268874 then 356 
 when 297585 then 357 
 when 293196 then 358 
 when 283873 then 359 
 when 227189 then 360 
 when 60299 then 361 
 when 253668 then 362 
 when 213786 then 363 
 when 23419 then 364 
 when 263808 then 365 
 when 218302 then 366 
 when 218301 then 367 
 when 124869 then 368 
 when 270669 then 369 
 when 203187 then 370 
 when 297064 then 371 
 when 36608 then 372 
 when 285851 then 373 
 when 254357 then 374 
 when 206667 then 375 
 when 170100 then 376 
 when 300579 then 377 
 when 310121 then 378 
 when 12671 then 379 
 when 77561 then 380 
 when 261502 then 381 
 when 60253 then 382 
 when 178636 then 383 
 when 251340 then 384 
 when 207310 then 385 
 when 135769 then 386 
 when 135482 then 387 
 when 182203 then 388 
 when 200772 then 389 
 when 288088 then 390 
 when 280322 then 391 
 when 202304 then 392 
 when 205211 then 393 
 when 199095 then 394 
 when 267175 then 395 
 when 276186 then 396 
 when 276183 then 397 
 when 283677 then 398 
 when 215534 then 399 
 when 296916 then 400 
 when 266628 then 401 
 when 293276 then 402 
 when 198573 then 403 
 when 247494 then 404 
 when 247493 then 405 
 when 289965 then 406 
 when 113257 then 407 
 when 4766 then 408 
 when 250181 then 409 
 when 296503 then 410 
 when 129242 then 411 
 when 273805 then 412 
 when 273262 then 413 
 when 304002 then 414 
 when 248148 then 415 
 when 267063 then 416 
 when 57208 then 417 
 when 253674 then 418 
 when 296761 then 419 
 when 291312 then 420 
 when 291316 then 421 
 when 248696 then 422 
 when 9149 then 423 
 when 144873 then 424 
 when 192280 then 425 
 when 264142 then 426 
 when 247499 then 427 
 when 293261 then 428 
 when 292145 then 429 
 when 129326 then 430 
 when 264431 then 431 
 when 173291 then 432 
 when 146845 then 433 
 when 7619 then 434 
 when 219936 then 435 
 when 275983 then 436 
 when 170313 then 437 
 when 296917 then 438 
 when 296158 then 439 
 when 296160 then 440 
 when 115793 then 441 
 when 280154 then 442 
 when 123331 then 443 
 when 85414 then 444 
 when 116209 then 445 
 when 85549 then 446 
 when 40374 then 447 
 when 153311 then 448 
 when 305037 then 449 
 when 247501 then 450 
 when 36595 then 451 
 when 73965 then 452 
 when 276348 then 453 
 when 287492 then 454 
 when 142969 then 455 
 when 205407 then 456 
 when 296162 then 457 
 when 114053 then 458 
 when 284337 then 459 
 when 20012 then 460 
 when 286221 then 461 
 when 246676 then 462 
 when 251305 then 463 
 when 264445 then 464 
 when 303078 then 465 
 when 208597 then 466 
 when 296685 then 467 
 when 202605 then 468 
 when 201640 then 469 
 when 79377 then 470 
 when 135771 then 471 
 when 262110 then 472 
 when 282912 then 473 
 when 191226 then 474 
 when 233210 then 475 
 when 251418 then 476 
 when 198817 then 477 
 when 236945 then 478 
 when 267296 then 479 
 when 266288 then 480 
 when 297675 then 481 
 when 216102 then 482 
 when 253524 then 483 
 when 147060 then 484 
 when 15733 then 485 
 when 203280 then 486 
 when 133339 then 487 
 when 266386 then 488 
 when 110707 then 489 
 when 216712 then 490 
 when 143020 then 491 
 when 214092 then 492 
 when 211439 then 493 
 when 138332 then 494 
 when 249244 then 495 
 when 299103 then 496 
 when 228041 then 497 
 when 35068 then 498 
 when 64750 then 499 
 when 211865 then 500 
 when 222708 then 501 
 when 222707 then 502 
 when 273250 then 503 
 when 290161 then 504 
 when 290165 then 505 
 when 81545 then 506 
 when 123065 then 507 
 when 255666 then 508 
 when 223101 then 509 
 when 141296 then 510 
 when 168616 then 511 
 when 249809 then 512 
 when 227162 then 513 
 when 268051 then 514 
 when 70588 then 515 
 when 211441 then 516 
 when 211442 then 517 
 when 36614 then 518 
 when 248407 then 519 
 when 271642 then 520 
 when 80044 then 521 
 when 207335 then 522 
 when 124744 then 523 
 when 184513 then 524 
 when 117700 then 525 
 when 102202 then 526 
 when 218303 then 527 
 when 276185 then 528 
 when 278989 then 529 
 when 278921 then 530 
 when 273255 then 531 
 when 99242 then 532 
 when 90898 then 533 
 when 223177 then 534 
 when 260576 then 535 
 when 287543 then 536 
 when 75750 then 537 
 when 205455 then 538 
 when 216513 then 539 
 when 247464 then 540 
 when 208384 then 541 
 when 269140 then 542 
 when 266930 then 543 
 when 305365 then 544 
 when 114677 then 545 
 when 294854 then 546 
 when 294878 then 547 
 when 165292 then 548 
 when 24541 then 549 
 when 36613 then 550 
 when 289703 then 551 
 when 164534 then 552 
 when 101930 then 553 
 when 181953 then 554 
 when 278938 then 555 
 when 274153 then 556 
 when 278924 then 557 
 when 218327 then 558 
 when 24696 then 559 
 when 116695 then 560 
 when 278923 then 561 
 when 156111 then 562 
 when 31933 then 563 
 when 141602 then 564 
 when 178992 then 565 
 when 165265 then 566 
 when 204702 then 567 
 when 301227 then 568 
 when 261 then 569 
 when 252430 then 570 
 when 170101 then 571 
 when 148056 then 572 
 when 172998 then 573 
 when 147916 then 574 
 when 308150 then 575 
 when 254241 then 576 
 when 188370 then 577 
 when 186713 then 578 
 when 104501 then 579 
 when 116923 then 580 
 when 254567 then 581 
 when 297792 then 582 
 when 307980 then 583 
 when 216542 then 584 
 when 196046 then 585 
 when 252417 then 586 
 when 41526 then 587 
 when 220026 then 588 
 when 276184 then 589 
 when 61829 then 590 
 when 253987 then 591 
 when 275955 then 592 
 when 249 then 593 
 when 252468 then 594 
 when 263898 then 595 
 when 263884 then 596 
 when 297891 then 597 
 when 208723 then 598 
 when 225701 then 599 
 when 309732 then 600 
 when 36623 then 601 
 when 292711 then 602 
 when 208722 then 603 
 when 19192 then 604 
 when 91482 then 605 
 when 124559 then 606 
 when 71645 then 607 
 when 148358 then 608 
 when 165141 then 609 
 when 192600 then 610 
 when 117193 then 611 
 when 102403 then 612 
 when 189572 then 613 
 when 265 then 614 
 when 138078 then 615 
 when 163600 then 616 
 when 41527 then 617 
 when 44752 then 618 
 when 307461 then 619 
 when 73370 then 620 
 when 223108 then 621 
 when 288944 then 622 
 when 267679 then 623 
 when 61837 then 624 
 when 263095 then 625 
 when 263096 then 626 
 when 267389 then 627 
 when 121206 then 628 
 when 270382 then 629 
 when 272035 then 630 
 when 113252 then 631 
 when 293284 then 632 
 when 217344 then 633 
 when 183760 then 634 
 when 190071 then 635 
 when 215097 then 636 
 when 215099 then 637 
 when 263866 then 638 
 when 282 then 639 
 when 202762 then 640 
 when 282715 then 641 
 when 203932 then 642 
 when 290169 then 643 
 when 245655 then 644 
 when 44625 then 645 
 when 207678 then 646 
 when 210600 then 647 
 when 210605 then 648 
 when 183759 then 649 
 when 258 then 650 
 when 260736 then 651 
 when 263880 then 652 
 when 41528 then 653 
 when 210607 then 654 
 when 182498 then 655 
 when 61979 then 656 
 when 61476 then 657 
 when 109005 then 658 
 when 310791 then 659 
 when 141648 then 660 
 when 262905 then 661 
 when 262904 then 662 
 when 4738 then 663 
 when 289961 then 664 
 when 288985 then 665 
 when 289962 then 666 
 when 289960 then 667 
 when 193098 then 668 
 when 255 then 669 
 when 256 then 670 
 when 210608 then 671 
 when 210606 then 672 
 when 263895 then 673 
 when 48786 then 674 
 when 210597 then 675 
 when 193137 then 676 
 when 217343 then 677 
 when 206593 then 678 
 when 263554 then 679 
 when 192050 then 680 
 when 193096 then 681 
 when 168040 then 682 
 when 196824 then 683 
 when 207676 then 684 
 when 260746 then 685 
 when 260527 then 686 
 when 44630 then 687 
 when 268296 then 688 
 when 112506 then 689 
 when 63792 then 690 
 when 256447 then 691 
 when 256449 then 692 
 when 268646 then 693 
 when 278380 then 694 
 when 303111 then 695 
 when 306834 then 696 
 when 303613 then 697 
 when 218300 then 698 
 when 247287 then 699 
 when 195975 then 700 
 when 23384 then 701 
 when 184270 then 702 
 when 260553 then 703 
 when 263888 then 704 
 when 260595 then 705 
 when 250 then 706 
 when 210681 then 707 
 when 205265 then 708 
 when 210680 then 709 
 when 67456 then 710 
 when 159150 then 711 
 when 276158 then 712 
 when 274642 then 713 
 when 305251 then 714 
 when 269260 then 715 
 when 269259 then 716 
 when 40295 then 717 
 when 179491 then 718 
 when 113248 then 719 
 when 252873 then 720 
 when 305086 then 721 
 when 250660 then 722 
 when 101303 then 723 
 when 51530 then 724 
 when 227137 then 725 
 when 260760 then 726 
 when 260558 then 727 
 when 210604 then 728 
 when 263140 then 729 
 when 263882 then 730 
 when 260744 then 731 
 when 264572 then 732 
 when 268038 then 733 
 when 193217 then 734 
 when 123484 then 735 
 when 193138 then 736 
 when 193133 then 737 
 when 218306 then 738 
 when 299129 then 739 
 when 281011 then 740 
 when 306710 then 741 
 when 123033 then 742 
 when 225851 then 743 
 when 256448 then 744 
 when 300623 then 745 
 when 264520 then 746 
 when 8392 then 747 
 when 183758 then 748 
 when 44626 then 749 
 when 165498 then 750 
 when 61367 then 751 
 when 254347 then 752 
 when 263890 then 753 
 when 260764 then 754 
 when 263899 then 755 
 when 260735 then 756 
 when 260596 then 757 
 when 285154 then 758 
 when 292777 then 759 
 when 79700 then 760 
 when 210596 then 761 
 when 44629 then 762 
 when 305039 then 763 
 when 282169 then 764 
 when 297725 then 765 
 when 173328 then 766 
 when 210598 then 767 
 when 225993 then 768 
 when 263892 then 769 
 when 269594 then 770 
 when 247281 then 771 
 when 248150 then 772 
 when 276159 then 773 
 when 274645 then 774 
 when 151585 then 775 
 when 183688 then 776 
 when 216776 then 777 
 when 260766 then 778 
 when 263883 then 779 
 when 263875 then 780 
 when 249177 then 781 
 when 104303 then 782 
 when 170576 then 783 
 when 249899 then 784 
 when 296192 then 785 
 when 203476 then 786 
 when 305109 then 787 
 when 210391 then 788 
 when 188439 then 789 
 when 220124 then 790 
 when 252438 then 791 
 when 260747 then 792 
 when 247709 then 793 
 when 263868 then 794 
 when 260765 then 795 
 when 263879 then 796 
 when 283 then 797 
 when 288048 then 798 
 when 263893 then 799 
 when 293145 then 800 
 when 297525 then 801 
 when 218305 then 802 
 when 282123 then 803 
 when 274644 then 804 
 when 289963 then 805 
 when 297727 then 806 
 when 298723 then 807 
 when 296559 then 808 
 when 264519 then 809 
 when 143337 then 810 
 when 48787 then 811 
 when 179790 then 812 
 when 197085 then 813 
 when 220123 then 814 
 when 216567 then 815 
 when 260703 then 816 
 when 283367 then 817 
 when 300913 then 818 
 when 286757 then 819 
 when 220172 then 820 
 when 225995 then 821 
 when 296153 then 822 
 when 195885 then 823 
 when 44836 then 824 
 when 112809 then 825 
 when 56318 then 826 
 when 172715 then 827 
 when 296286 then 828 
 when 167934 then 829 
 when 210160 then 830 
 when 22937 then 831 
 when 201460 then 832 
 when 205079 then 833 
 when 198989 then 834 
 when 277240 then 835 
 when 145418 then 836 
 when 207599 then 837 
 when 207598 then 838 
 when 225975 then 839 
 when 250673 then 840 
 when 262588 then 841 
 when 293263 then 842 
 when 289578 then 843 
 when 305065 then 844 
 when 141247 then 845 
 when 220173 then 846 
 when 220892 then 847 
 when 257192 then 848 
 when 116595 then 849 
 when 155184 then 850 
 when 289412 then 851 
 when 264012 then 852 
 when 254561 then 853 
 when 290170 then 854 
 when 245075 then 855 
 when 202639 then 856 
 when 124407 then 857 
 when 173188 then 858 
 when 175892 then 859 
 when 122021 then 860 
 when 210177 then 861 
 when 53936 then 862 
 when 296914 then 863 
 when 253384 then 864 
 when 290195 then 865 
 when 106165 then 866 
 when 157762 then 867 
 when 191231 then 868 
 when 193162 then 869 
 when 248701 then 870 
 when 264189 then 871 
 when 278 then 872 
 when 250497 then 873 
 when 291988 then 874 
 when 262522 then 875 
 when 22930 then 876 
 when 289766 then 877 
 when 296164 then 878 
 when 296298 then 879 
 when 296186 then 880 
 when 286467 then 881 
 when 23956 then 882 
 when 114868 then 883 
 when 161644 then 884 
 when 302754 then 885 
 when 23395 then 886 
 when 154876 then 887 
 when 250964 then 888 
 when 263869 then 889 
 when 286666 then 890 
 when 257195 then 891 
 when 293280 then 892 
 when 202383 then 893 
 when 252081 then 894 
 when 250198 then 895 
 when 297719 then 896 
 when 232439 then 897 
 when 196825 then 898 
 when 124243 then 899 
 when 281969 then 900 
 when 282284 then 901 
 when 257188 then 902 
 when 155642 then 903 
 when 198038 then 904 
 when 296901 then 905 
 when 299119 then 906 
 when 263377 then 907 
 when 141298 then 908 
 when 253141 then 909 
 when 22932 then 910 
 when 251569 then 911 
 when 266716 then 912 
 when 215618 then 913 
 when 250748 then 914 
 when 253385 then 915 
 when 263399 then 916 
 when 297828 then 917 
 when 257193 then 918 
 when 286957 then 919 
 when 197082 then 920 
 when 252492 then 921 
 when 191930 then 922 
 when 155348 then 923 
 when 247465 then 924 
 when 218304 then 925 
 when 252220 then 926 
 when 272649 then 927 
 when 279404 then 928 
 when 279525 then 929 
 when 218308 then 930 
 when 246335 then 931 
 when 232275 then 932 
 when 262431 then 933 
 when 287554 then 934 
 when 297301 then 935 
 when 280453 then 936 
 when 293273 then 937 
 when 225319 then 938 
 when 242383 then 939 
 when 286225 then 940 
 when 220170 then 941 
 when 297587 then 942 
 when 305051 then 943 
 when 305055 then 944 
 when 305059 then 945 
 when 257194 then 946 
 when 251168 then 947 
 when 286219 then 948 
 when 159327 then 949 
 when 44756 then 950 
 when 287570 then 951 
 when 291886 then 952 
 when 44753 then 953 
 when 261496 then 954 
 when 285027 then 955 
 when 307658 then 956 
 when 278395 then 957 
 when 305049 then 958 
 when 257197 then 959 
 when 276303 then 960 
 when 286811 then 961 
 when 247219 then 962 
 when 164698 then 963 
 when 286 then 964 
 when 93521 then 965 
 when 291875 then 966 
 when 2819 then 967 
 when 131889 then 968 
 when 294980 then 969 
 when 293493 then 970 
 when 302569 then 971 
 when 266962 then 972 
 when 278384 then 973 
 when 276306 then 974 
 when 206482 then 975 
 when 7523 then 976 
 when 114313 then 977 
 when 157975 then 978 
 when 85877 then 979 
 when 7522 then 980 
 when 285182 then 981 
 when 285170 then 982 
 when 206508 then 983 
 when 110980 then 984 
 when 291887 then 985 
 when 228042 then 986 
 when 181955 then 987 
 when 283476 then 988 
 when 288588 then 989 
 when 253993 then 990 
 when 289702 then 991 
 when 44632 then 992 
 when 264198 then 993 
 when 285342 then 994 
 when 290520 then 995 
 when 290515 then 996 
 when 255679 then 997 
 when 302574 then 998 
 when 302575 then 999 
 when 205229 then 1000 
 else 1000 
 
 end as ranking,
 
 
 
 max(a.non_invt) as non_invt,sum(qoh + qc) as available,max(a.dept) as dept,max(a.brand) as brand,max(a.of3) as of3,case when sum(qoh + qc) > 0 then 1 else 0 end as instock
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id and c.store_id=10)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
 where a.style_id in (123774,123997,309353,268616,151161,298346,162071,96036,249289,179649,262789,262786,278790,262787,278792,114636,278789,262788,262785,281593,169790,125824,124084,102294,13880,254378,196372,176432,264021,274155,125506,129071,73377,188658,206165,211308,301818,113256,294638,113259,113258,157814,155325,155326,60304,129072,112778,113775,175529,163820,141442,278799,155531,155707,153394,151120,249294,264023,193177,193170,193175,193176,227139,226079,172343,147500,22910,193161,132455,138430,288126,248839,147372,247275,290518,291873,309332,263885,292051,232185,260691,263876,247277,138429,267463,195643,117136,155342,296224,296429,23952,250963,44757,206503,205230,260698,260758,266940,156651,161606,266942,263891,205082,142999,249560,184032,131365,266941,149795,149799,206286,305046,44754,124007,102137,158990,22936,250769,282191,229142,247581,285144,61945,121650,301816,158504,23379,108208,144634,175327,61833,108807,293042,257011,36610,297892,173699,303610,147502,112779,75029,179775,252219,125778,165139,159122,267630,42264,161536,189907,257087,189906,197835,112078,165130,277581,161337,214082,193148,36622,267710,257024,213251,193157,108741,161335,290036,217694,290041,285678,291965,22908,247663,150075,271791,113118,176063,289443,289434,300593,121561,273263,107404,23391,145410,225887,74926,281594,7339,127015,281256,266632,195861,153353,260969,277071,277073,280317,277038,290037,107665,169754,301817,133125,282175,165311,129145,227148,285765,292373,277072,292144,168709,281089,285951,289038,4473,287422,123667,176459,161668,247528,23410,193141,266102,286272,279940,117771,276668,287624,121755,68469,56380,205776,273433,288582,203321,283371,283212,133694,286274,117637,251722,257088,267765,293008,252874,117577,222537,120478,44677,119052,213252,59844,135490,252485,297549,202771,193278,309733,141297,253445,204268,193139,213783,246217,302337,300646,139985,279998,271477,194075,218523,267028,297545,263765,305217,216748,298378,168708,173050,122387,286923,75189,306716,247495,247498,247500,23409,227194,222566,283436,281103,4747,137552,272145,124425,196898,210683,280321,58934,260755,263688,301820,170759,153053,134636,291471,44842,255787,260834,60285,289549,267031,213253,170447,84075,215985,206509,297396,172030,154577,85475,219848,260564,268873,272954,203293,278922,141443,206666,281255,233710,60301,203499,306704,244952,124936,121987,12669,282380,291252,281683,201672,245412,252688,84849,283360,288084,247770,254112,205208,201266,261499,194068,268874,297585,293196,283873,227189,60299,253668,213786,23419,263808,218302,218301,124869,270669,203187,297064,36608,285851,254357,206667,170100,300579,310121,12671,77561,261502,60253,178636,251340,207310,135769,135482,182203,200772,288088,280322,202304,205211,199095,267175,276186,276183,283677,215534,296916,266628,293276,198573,247494,247493,289965,113257,4766,250181,296503,129242,273805,273262,304002,248148,267063,57208,253674,296761,291312,291316,248696,9149,144873,192280,264142,247499,293261,292145,129326,264431,173291,146845,7619,219936,275983,170313,296917,296158,296160,115793,280154,123331,85414,116209,85549,40374,153311,305037,247501,36595,73965,276348,287492,142969,205407,296162,114053,284337,20012,286221,246676,251305,264445,303078,208597,296685,202605,201640,79377,135771,262110,282912,191226,233210,251418,198817,236945,267296,266288,297675,216102,253524,147060,15733,203280,133339,266386,110707,216712,143020,214092,211439,138332,249244,299103,228041,35068,64750,211865,222708,222707,273250,290161,290165,81545,123065,255666,223101,141296,168616,249809,227162,268051,70588,211441,211442,36614,248407,271642,80044,207335,124744,184513,117700,102202,218303,276185,278989,278921,273255,99242,90898,223177,260576,287543,75750,205455,216513,247464,208384,269140,266930,305365,114677,294854,294878,165292,24541,36613,289703,164534,101930,181953,278938,274153,278924,218327,24696,116695,278923,156111,31933,141602,178992,165265,204702,301227,261,252430,170101,148056,172998,147916,308150,254241,188370,186713,104501,116923,254567,297792,307980,216542,196046,252417,41526,220026,276184,61829,253987,275955,249,252468,263898,263884,297891,208723,225701,309732,36623,292711,208722,19192,91482,124559,71645,148358,165141,192600,117193,102403,189572,265,138078,163600,41527,44752,307461,73370,223108,288944,267679,61837,263095,263096,267389,121206,270382,272035,113252,293284,217344,183760,190071,215097,215099,263866,282,202762,282715,203932,290169,245655,44625,207678,210600,210605,183759,258,260736,263880,41528,210607,182498,61979,61476,109005,310791,141648,262905,262904,4738,289961,288985,289962,289960,193098,255,256,210608,210606,263895,48786,210597,193137,217343,206593,263554,192050,193096,168040,196824,207676,260746,260527,44630,268296,112506,63792,256447,256449,268646,278380,303111,306834,303613,218300,247287,195975,23384,184270,260553,263888,260595,250,210681,205265,210680,67456,159150,276158,274642,305251,269260,269259,40295,179491,113248,252873,305086,250660,101303,51530,227137,260760,260558,210604,263140,263882,260744,264572,268038,193217,123484,193138,193133,218306,299129,281011,306710,123033,225851,256448,300623,264520,8392,183758,44626,165498,61367,254347,263890,260764,263899,260735,260596,285154,292777,79700,210596,44629,305039,282169,297725,173328,210598,225993,263892,269594,247281,248150,276159,274645,151585,183688,216776,260766,263883,263875,249177,104303,170576,249899,296192,203476,305109,210391,188439,220124,252438,260747,247709,263868,260765,263879,283,288048,263893,293145,297525,218305,282123,274644,289963,297727,298723,296559,264519,143337,48787,179790,197085,220123,216567,260703,283367,300913,286757,220172,225995,296153,195885,44836,112809,56318,172715,296286,167934,210160,22937,201460,205079,198989,277240,145418,207599,207598,225975,250673,262588,293263,289578,305065,141247,220173,220892,257192,116595,155184,289412,264012,254561,290170,245075,202639,124407,173188,175892,122021,210177,53936,296914,253384,290195,106165,157762,191231,193162,248701,264189,278,250497,291988,262522,22930,289766,296164,296298,296186,286467,23956,114868,161644,302754,23395,154876,250964,263869,286666,257195,293280,202383,252081,250198,297719,232439,196825,124243,281969,282284,257188,155642,198038,296901,299119,263377,141298,253141,22932,251569,266716,215618,250748,253385,263399,297828,257193,286957,197082,252492,191930,155348,247465,218304,252220,272649,279404,279525,218308,246335,232275,262431,287554,297301,280453,293273,225319,242383,286225,220170,297587,305051,305055,305059,257194,251168,286219,159327,44756,287570,291886,44753,261496,285027,307658,278395,305049,257197,276303,286811,247219,164698,286,93521,291875,2819,131889,294980,293493,302569,266962,278384,276306,206482,7523,114313,157975,85877,7522,285182,285170,206508,110980,291887,228042,181955,283476,288588,253993,289702,44632,264198,285342,290520,290515,255679,302574,302575,205229)
 
 
  and ltrim(rtrim(lower(a.dept))) = 'smith & wesson'
 
	and a.of3='22 LR'
	
 group by a.style_id 
  order by  instock desc, ranking asc

select distinct dept from mysearch where dept <> 'EMPTY'
  order by dept asc

select distinct brand from mysearch
  order by brand asc

select distinct of3 from mysearch
  order by of3 asc

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\websites\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\websites\images\
logdir=E:\websites\logs\
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\websites\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\search.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=CFTOKEN=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876; CFID=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-5054; CFGLOBALS=urltoken%3DCFID%23%3D5054%26CFTOKEN%23%3Dae2897c1f26072f5%2DE8E457D9%2DC345%2D0FDC%2D1A536E3A78F8D876%23lastvisit%3D%7Bts%20%272024%2D05%2D20%2014%3A36%3A42%27%7D%23hitcount%3D77%23timecreated%3D%7Bts%20%272024%2D05%2D20%2014%3A36%3A02%27%7D%23cftoken%3Dae2897c1f26072f5%2DE8E457D9%2DC345%2D0FDC%2D1A536E3A78F8D876%23cfid%3D5054%23; LAST_NAME=; FIRST_NAME=; PRD_U=307380%2C3273; CUSTOMER_ID=; USERNAME=; EMAIL=; PASSWORD=; CT_U=91
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/search.cfm/CurrentPage/2/kword/colt%20m4%2022/dept/smith%20and%20wesson/of3/22-lr
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/CurrentPage/2/kword/colt m4 22/dept/smith and wesson/of3/22-lr
PATH_TRANSLATED=E:\inetpub\wwwroot\search.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/search.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=5054
cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
hitcount=77
lastvisit={ts '2024-05-20 14:36:42'}
timecreated={ts '2024-05-20 14:36:02'}
urltoken=CFID=5054&CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876

Cookie Variables:
CFGLOBALS=urltoken=CFID#=5054&CFTOKEN#=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876#lastvisit={ts '2024-05-20 14:36:42'}#hitcount=77#timecreated={ts '2024-05-20 14:36:02'}#cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876#cfid=5054#
CFID=5054
CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
CT_U=91
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=307380,3273
USERNAME=

Form Fields:
KWORD=colt m4 22
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=5054
cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
cs=/category.cfm/CurrentPage/3/brand/RCBS/rebate/buy-green-get-green-314
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_5054_ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
strarray=Array (0)
urltoken=CFID=5054&CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876

URL Parameters:
BRAND=
CLEARANCE=
CurrentPage=2
DISPLAYCOUNT=18
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WHATSNEW=
dept=smith and wesson
kword=colt m4 22
of3=22-lr